Specify fields that should not have a default value assigned to them in New mode.
Description
A default value displays in a field when a module is opened in New or Search mode. A default value is the most commonly used value in a field and is intended to save time and effort during data entry. The Insert Defaults Registry entry specifies a set of values to display by default in a module when the module enters New mode.
It might not be appropriate for some fields (System populated fields such as date fields, for example) to have a default value assigned to them. The purpose of Insert Defaults Skip Columns is to specify fields that should be excluded from a set of default fields, and thus never have a default value associated with them.
Note: The purpose of the Insert Defaults Skip Columns Registry entry is to stop users from specifying a default value for an excluded field when using the Edit>Default Values>Set as Defaults menu option in a module. An Administrator is always able to set any field as a default in Insert mode (excluding IRN), even if an Insert Defaults Skip Columns Registry explicitly excludes it.
Note: IRN is never stored as a default and it is not necessary to specify an Insert Defaults Skip Columns entry for IRN.
Usage
This Registry entry can be assigned to users and groups:
| Key | User | User | Group | Group | Group | Group |
|---|---|---|---|---|---|---|
| Key 1 | User
|
User
|
Group
|
Group
|
Group
|
Group
|
| Key 2 | user | user | group | group | Default
|
Default
|
| Key 3 | Table
|
Table
|
Table
|
Table
|
Table
|
Table
|
| Key 4 | table | Default
|
table | Default
|
table | Default
|
| Key 5 | Insert Defaults Skip Columns
|
|||||
| Value | column;column;... | |||||
In pipe-delimited format:
User
|
user | Table
|
table | Insert Defaults Skip Columns
|
column;column;... |
User
|
user | Table
|
Default
|
Insert Defaults Skip Columns
|
column;column;... |
Group
|
group | Table
|
table | Insert Defaults Skip Columns
|
column;column;... |
Group
|
group | Table
|
Default
|
Insert Defaults Skip Columns
|
column;column;... |
Group
|
Default
|
Table
|
table | Insert Defaults Skip Columns
|
column;column;... |
Group
|
Default
|
Table
|
Default
|
Insert Defaults Skip Columns
|
column;column;... |
where:
|
column;column;... |
is a semicolon separated list of column names. |
Example
This entry could be used in order that fields set by the System do not have defaults assigned to them in New mode:
| Key | Setting |
|---|---|
| Key 1 | Group
|
| Key 2 | Default
|
| Key 3 | Table
|
| Key 4 | Default
|
| Key 5 | Insert Defaults Skip Columns
|
| Value | AdmInsertedBy;AdmDateInserted;AdmTimeInserted;AdmDateModified;AdmTimeModified; AdmModifiedBy;AdmPublishWebNoPassword;AdmPublishWebPassword
|